| |
13 Search Results Found |
| 1 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 11 April 2014 01:32 «»
By: Bikash.p
Re: Export of Table Data to Excel through PL/SQL code
…Hi,Bikash
Why you want to export?
Any way you can use Sql Developer. In Version 3.2.20.09 or more is very flexible for import and export. As per your table structure its easy to use Sql Developer.
Right Click on Table-->Export-->Under …
|
| 2 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 20 January 2012 07:43 «»
By: bikash
Re: Export of Table Data to Excel through PL/SQL code
…office n i can check this on Monday only due to some work.As you suggested i have the scenario as:
A table temp1 has 10 columns and 1000 rows and i have to export this data to an excel file through stored procedure.
Thanks & Regards
Bikash…
|
| 3 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 20 January 2012 07:19 «»
By: bikash
Export of Table Data to Excel through PL/SQL code
Hi Friends,
Please provide us the code for:
Export table data to excel file in Oracle PL/SQL.
Regards
Bikash
|
| 4 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 14 June 2010 05:16 «»
By: bikash
How to run a sql file from procedure
…I want to do the same embedded in a procedure.
create or replace procedure test_csv
as
begin
@d:\test\EndItem_Vio_Item_Material_Violations.sql;
end;
Please let me know as how can I run the sql file in a procedure.
Regards,
Bikash…
|
| 5 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 10 February 2005 14:24 «»
By: bikash karan
query outpou
… 1 a
c 1 a
d 2 a
The output should be like this :
emp_id context
1 a
1 b
1 c
The another output which i need is the count of each emp id i.e. o/p is 3 for emp_id=1.
Please help.
Regards
Bikash …
|
| 6 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 18 November 2004 13:28 «»
By: Barbara Boehmer
Re: how to create database link
You need to put the connect string within single quotes and use the connect string of the database that you want to connect to:
create database link s_2_b
connect to bikash
identified by karan
using 'sales.cos.com';
|
| 7 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 18 November 2004 10:46 «»
By: bikash karan
how to create database link
…need to create a DB link.
SQL> connect bikash/karan@sales.cos.com
Connected.
SQL> connect satish/satish@demo.cos.com
Connected.
Please clarify what is this host string : Is is demo.cos.com or sales.cos.com or is this something else...............…
|
| 8 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 18 November 2004 09:38 «»
By: bikash karan
Re: ORA-04091: table is mutating, trigger/function may not see it
…A set y=y+2 where x=1;
1 row updated
SQL> select * from A;
X Y Z
--- --- ---
1 12 48
2 15 60
Note : Cause of mutating : performing DML or select on the triggering table in the pl/sql block.
You were doing the same.
Regards
bikash…
|
| 9 |
Forum: Forms «»
Posted on: Wed, 13 October 2004 13:56 «»
By: bikash karan
FRM-92045 :FAILED TO CONNECT TO THE SERVER/FORMS
Hi friends ...
i am finding this message when i try to run the form.
I have even started the http server , as given in the problem.
please let me know...how to recover from this error.
Thanks and regards
bikash
|
| 10 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 01 October 2004 00:31 «»
By: bikash karan
Re: OCA
… Instructor Led Training materials provided by oracle University.
All most all the question are from that book only.
I have cleared 1Z0-007 , and i had referred this book only.
As said , there is no time gap between two examination.
Regards
Bikash …
|
| 11 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 23 September 2004 02:04 «»
By: bikash karan
Invokers and definers right
… give explict access right to all the objects the Procedure is referencing like any function or table.
what is the situation when we are using AUTHID current_user .
Please help me out ...I m in confusion.
Regards
Bikash Karan
…
|
| 12 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 22 September 2004 03:29 «»
By: bikash karan
Re: PL/SQL doubts
… really a miss from my side, bec ause even if we use : Grant execute on procedure_name to public.
the table will be available for insert from any user.
Thus including the "revoke" would be the correct answer.
Thanks a lot.
Regards
Bikash …
|
| 13 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 20 September 2004 04:11 «»
By: bikash karan
Re: PL/SQL doubts
Hi ,
I checked the answer on my own:-
1 C
2 B
3 3.
I hope this is correct
regards
Bikash
|
Blog
Search
Help
Members
Register
Login
Home